/*-------------------------------------------------------------------------*
 |                                                                         
 |            STATA SUPPLEMENTAL SYNTAX FILE FOR ICPSR 38651
 |        LAW ENFORCEMENT MANAGEMENT AND ADMINISTRATIVE STATISTICS
 |                             (LEMAS), 2020
 |
 |
 | This Stata missing value recode program is provided for optional use with
 | the Stata system version of this data file as distributed by ICPSR.
 | The program replaces user-defined numeric missing values (e.g., -9)
 | with generic system missing "."  Note that Stata allows you to specify
 | up to 27 unique missing value codes.  Only variables with user-defined
 | missing values are included in this program.
 |
 | To apply the missing value recodes, users need to first open the
 | Stata data file on their system, apply the missing value recodes if
 | desired, then save a new copy of the data file with the missing values
 | applied.  Users are strongly advised to use a different filename when
 | saving the new file.
 |
 *------------------------------------------------------------------------*/

replace SUBMIT_DATE = "" if (SUBMIT_DATE == " ")
replace ORI9 = "" if (ORI9 == "-1" | ORI9 == "-9")
replace ORI7 = "" if (ORI7 == "-1" | ORI7 == "-9")
replace SAMPLINGWEIGHT = . if (SAMPLINGWEIGHT == -8.0 | SAMPLINGWEIGHT == -9.0)
replace FTSWORN_2019 = . if (FTSWORN_2019 == -8 | FTSWORN_2019 == -9)
replace PTSWORN_2019 = . if (PTSWORN_2019 == -8 | PTSWORN_2019 == -9)
replace FTLIM_2019 = . if (FTLIM_2019 == -8 | FTLIM_2019 == -9)
replace PTLIM_2019 = . if (PTLIM_2019 == -8 | PTLIM_2019 == -9)
replace FTNON_2019 = . if (FTNON_2019 == -8 | FTNON_2019 == -9)
replace PTNON_2019 = . if (PTNON_2019 == -8 | PTNON_2019 == -9)
replace TOTFTEMP_2019 = . if (TOTFTEMP_2019 == -8 | TOTFTEMP_2019 == -9)
replace TOTPTEMP_2019 = . if (TOTPTEMP_2019 == -8 | TOTPTEMP_2019 == -9)
replace FTSWORN = . if (FTSWORN == -8 | FTSWORN == -9)
replace PTSWORN = . if (PTSWORN == -8 | PTSWORN == -9)
replace FTLIM = . if (FTLIM == -8 | FTLIM == -9)
replace PTLIM = . if (PTLIM == -8 | PTLIM == -9)
replace FTNON = . if (FTNON == -8 | FTNON == -9)
replace PTNON = . if (PTNON == -8 | PTNON == -9)
replace TOTFTEMP = . if (TOTFTEMP == -8 | TOTFTEMP == -9)
replace TOTPTEMP = . if (TOTPTEMP == -8 | TOTPTEMP == -9)
replace FTVAC_2019 = . if (FTVAC_2019 == -8 | FTVAC_2019 == -9)
replace FTVAC = . if (FTVAC == -8 | FTVAC == -9)
replace ADMIN_SWN = . if (ADMIN_SWN == -8 | ADMIN_SWN == -9)
replace ADMIN_LIM = . if (ADMIN_LIM == -8 | ADMIN_LIM == -9)
replace ADMIN_NON = . if (ADMIN_NON == -8 | ADMIN_NON == -9)
replace OP_TOTAL_SWN = . if (OP_TOTAL_SWN == -8 | OP_TOTAL_SWN == -9)
replace OP_TOTAL_LIM = . if (OP_TOTAL_LIM == -8 | OP_TOTAL_LIM == -9)
replace OP_TOTAL_NON = . if (OP_TOTAL_NON == -8 | OP_TOTAL_NON == -9)
replace OP_SWN_OFF = . if (OP_SWN_OFF == -8 | OP_SWN_OFF == -9)
replace OP_LIM_OFF = . if (OP_LIM_OFF == -8 | OP_LIM_OFF == -9)
replace OP_NON_OFF = . if (OP_NON_OFF == -8 | OP_NON_OFF == -9)
replace DET_SWN = . if (DET_SWN == -8 | DET_SWN == -9)
replace DET_LIM = . if (DET_LIM == -8 | DET_LIM == -9)
replace DET_NON = . if (DET_NON == -8 | DET_NON == -9)
replace OP_SWN_OTH = . if (OP_SWN_OTH == -8 | OP_SWN_OTH == -9)
replace OP_LIM_OTH = . if (OP_LIM_OTH == -8 | OP_LIM_OTH == -9)
replace OP_NON_OTH = . if (OP_NON_OTH == -8 | OP_NON_OTH == -9)
replace JAIL_SWN = . if (JAIL_SWN == -8 | JAIL_SWN == -9)
replace JAIL_LIM = . if (JAIL_LIM == -8 | JAIL_LIM == -9)
replace JAIL_NON = . if (JAIL_NON == -8 | JAIL_NON == -9)
replace COURT_SWN = . if (COURT_SWN == -8 | COURT_SWN == -9)
replace COURT_LIM = . if (COURT_LIM == -8 | COURT_LIM == -9)
replace COURT_NON = . if (COURT_NON == -8 | COURT_NON == -9)
replace CIVIL_SWN = . if (CIVIL_SWN == -8 | CIVIL_SWN == -9)
replace CIVIL_LIM = . if (CIVIL_LIM == -8 | CIVIL_LIM == -9)
replace CIVIL_NON = . if (CIVIL_NON == -8 | CIVIL_NON == -9)
replace SUP_TOTAL_SWN = . if (SUP_TOTAL_SWN == -8 | SUP_TOTAL_SWN == -9)
replace SUP_TOTAL_LIM = . if (SUP_TOTAL_LIM == -8 | SUP_TOTAL_LIM == -9)
replace SUP_TOTAL_NON = . if (SUP_TOTAL_NON == -8 | SUP_TOTAL_NON == -9)
replace SUP_DIS_SWN = . if (SUP_DIS_SWN == -8 | SUP_DIS_SWN == -9)
replace SUP_DIS_LIM = . if (SUP_DIS_LIM == -8 | SUP_DIS_LIM == -9)
replace SUP_DIS_NON = . if (SUP_DIS_NON == -8 | SUP_DIS_NON == -9)
replace SUP_OTH_SWN = . if (SUP_OTH_SWN == -8 | SUP_OTH_SWN == -9)
replace SUP_OTH_LIM = . if (SUP_OTH_LIM == -8 | SUP_OTH_LIM == -9)
replace SUP_OTH_NON = . if (SUP_OTH_NON == -8 | SUP_OTH_NON == -9)
replace OTHER_SWN = . if (OTHER_SWN == -8 | OTHER_SWN == -9)
replace OTHER_LIM = . if (OTHER_LIM == -8 | OTHER_LIM == -9)
replace OTHER_NON = . if (OTHER_NON == -8 | OTHER_NON == -9)
replace PERS_WHITE_MALE = . if (PERS_WHITE_MALE == -8 | PERS_WHITE_MALE == -9)
replace PERS_WHITE_FEM = . if (PERS_WHITE_FEM == -8 | PERS_WHITE_FEM == -9)
replace PERS_BLACK_MALE = . if (PERS_BLACK_MALE == -8 | PERS_BLACK_MALE == -9)
replace PERS_BLACK_FEM = . if (PERS_BLACK_FEM == -8 | PERS_BLACK_FEM == -9)
replace PERS_HISP_MALE = . if (PERS_HISP_MALE == -8 | PERS_HISP_MALE == -9)
replace PERS_HISP_FEM = . if (PERS_HISP_FEM == -8 | PERS_HISP_FEM == -9)
replace PERS_AMIND_MALE = . if (PERS_AMIND_MALE == -8 | PERS_AMIND_MALE == -9)
replace PERS_AMIND_FEM = . if (PERS_AMIND_FEM == -8 | PERS_AMIND_FEM == -9)
replace PERS_ASIAN_MALE = . if (PERS_ASIAN_MALE == -8 | PERS_ASIAN_MALE == -9)
replace PERS_ASIAN_FEM = . if (PERS_ASIAN_FEM == -8 | PERS_ASIAN_FEM == -9)
replace PERS_HAWPI_MALE = . if (PERS_HAWPI_MALE == -8 | PERS_HAWPI_MALE == -9)
replace PERS_HAWPI_FEM = . if (PERS_HAWPI_FEM == -8 | PERS_HAWPI_FEM == -9)
replace PERS_MULTI_MALE = . if (PERS_MULTI_MALE == -8 | PERS_MULTI_MALE == -9)
replace PERS_MULTI_FEM = . if (PERS_MULTI_FEM == -8 | PERS_MULTI_FEM == -9)
replace PERS_UNK_MALE = . if (PERS_UNK_MALE == -8 | PERS_UNK_MALE == -9)
replace PERS_UNK_FEM = . if (PERS_UNK_FEM == -8 | PERS_UNK_FEM == -9)
replace PERS_MALE = . if (PERS_MALE == -8 | PERS_MALE == -9)
replace PERS_FEMALE = . if (PERS_FEMALE == -8 | PERS_FEMALE == -9)
replace PERS_CHF_SEX = . if (PERS_CHF_SEX == -8 | PERS_CHF_SEX == -9)
replace PERS_CHF_HISP_OR = . if (PERS_CHF_HISP_OR == -8 | PERS_CHF_HISP_OR == -9)
replace PERS_CHF_RACE_WHT = . if (PERS_CHF_RACE_WHT == -8 | PERS_CHF_RACE_WHT == -9)
replace PERS_CHF_RACE_BK = . if (PERS_CHF_RACE_BK == -8 | PERS_CHF_RACE_BK == -9)
replace PERS_CHF_RACE_AMER = . if (PERS_CHF_RACE_AMER == -8 | PERS_CHF_RACE_AMER == -9)
replace PERS_CHF_RACE_ASIAN = . if (PERS_CHF_RACE_ASIAN == -8 | PERS_CHF_RACE_ASIAN == -9)
replace PERS_CHF_RACE_HAWPI = . if (PERS_CHF_RACE_HAWPI == -8 | PERS_CHF_RACE_HAWPI == -9)
replace PERS_CHF_RACE_OTH = . if (PERS_CHF_RACE_OTH == -8 | PERS_CHF_RACE_OTH == -9)
replace PERS_SUP_INTM_NA = . if (PERS_SUP_INTM_NA == -8 | PERS_SUP_INTM_NA == -9)
replace PERS_SUP_SGT_NA = . if (PERS_SUP_SGT_NA == -8 | PERS_SUP_SGT_NA == -9)
replace PERS_SUP_INTM_WH = . if (PERS_SUP_INTM_WH == -8 | PERS_SUP_INTM_WH == -9)
replace PERS_SUP_SGT_WH = . if (PERS_SUP_SGT_WH == -8 | PERS_SUP_SGT_WH == -9)
replace PERS_SUP_INTM_BK = . if (PERS_SUP_INTM_BK == -8 | PERS_SUP_INTM_BK == -9)
replace PERS_SUP_SGT_BK = . if (PERS_SUP_SGT_BK == -8 | PERS_SUP_SGT_BK == -9)
replace PERS_SUP_INTM_HS = . if (PERS_SUP_INTM_HS == -8 | PERS_SUP_INTM_HS == -9)
replace PERS_SUP_SGT_HS = . if (PERS_SUP_SGT_HS == -8 | PERS_SUP_SGT_HS == -9)
replace PERS_SUP_INTM_AI = . if (PERS_SUP_INTM_AI == -8 | PERS_SUP_INTM_AI == -9)
replace PERS_SUP_SGT_AI = . if (PERS_SUP_SGT_AI == -8 | PERS_SUP_SGT_AI == -9)
replace PERS_SUP_INTM_AS = . if (PERS_SUP_INTM_AS == -8 | PERS_SUP_INTM_AS == -9)
replace PERS_SUP_SGT_AS = . if (PERS_SUP_SGT_AS == -8 | PERS_SUP_SGT_AS == -9)
replace PERS_SUP_INTM_HA = . if (PERS_SUP_INTM_HA == -8 | PERS_SUP_INTM_HA == -9)
replace PERS_SUP_SGT_HA = . if (PERS_SUP_SGT_HA == -8 | PERS_SUP_SGT_HA == -9)
replace PERS_SUP_INTM_MUL = . if (PERS_SUP_INTM_MUL == -8 | PERS_SUP_INTM_MUL == -9)
replace PERS_SUP_SGT_MUL = . if (PERS_SUP_SGT_MUL == -8 | PERS_SUP_SGT_MUL == -9)
replace PERS_SUP_INTM_UNK = . if (PERS_SUP_INTM_UNK == -8 | PERS_SUP_INTM_UNK == -9)
replace PERS_SUP_SGT_UNK = . if (PERS_SUP_SGT_UNK == -8 | PERS_SUP_SGT_UNK == -9)
replace PERS_SUP_INTM_TOTR = . if (PERS_SUP_INTM_TOTR == -8 | PERS_SUP_INTM_TOTR == -9)
replace PERS_SUP_SGT_TOTR = . if (PERS_SUP_SGT_TOTR == -8 | PERS_SUP_SGT_TOTR == -9)
replace PERS_SUP_INTM_MALE = . if (PERS_SUP_INTM_MALE == -8 | PERS_SUP_INTM_MALE == -9)
replace PERS_SUP_SGT_MALE = . if (PERS_SUP_SGT_MALE == -8 | PERS_SUP_SGT_MALE == -9)
replace PERS_SUP_INTM_FEM = . if (PERS_SUP_INTM_FEM == -8 | PERS_SUP_INTM_FEM == -9)
replace PERS_SUP_SGT_FEM = . if (PERS_SUP_SGT_FEM == -8 | PERS_SUP_SGT_FEM == -9)
replace PERS_SUP_INTM_TOTS = . if (PERS_SUP_INTM_TOTS == -8 | PERS_SUP_INTM_TOTS == -9)
replace PERS_SUP_SGT_TOTS = . if (PERS_SUP_SGT_TOTS == -8 | PERS_SUP_SGT_TOTS == -9)
replace PERS_BILING_SWN = . if (PERS_BILING_SWN == -8 | PERS_BILING_SWN == -9)
replace PERS_BILING_LIM = . if (PERS_BILING_LIM == -8 | PERS_BILING_LIM == -9)
replace PERS_BILING_NON = . if (PERS_BILING_NON == -8 | PERS_BILING_NON == -9)
replace ISSU_ADDR_AGSTAND = . if (ISSU_ADDR_AGSTAND == -8 | ISSU_ADDR_AGSTAND == -9)
replace ISSU_ADDR_BIAS = . if (ISSU_ADDR_BIAS == -8 | ISSU_ADDR_BIAS == -9)
replace ISSU_ADDR_BOMB = . if (ISSU_ADDR_BOMB == -8 | ISSU_ADDR_BOMB == -9)
replace ISSU_ADDR_CHILD = . if (ISSU_ADDR_CHILD == -8 | ISSU_ADDR_CHILD == -9)
replace ISSU_ADDR_CP = . if (ISSU_ADDR_CP == -8 | ISSU_ADDR_CP == -9)
replace ISSU_ADDR_CRMANL = . if (ISSU_ADDR_CRMANL == -8 | ISSU_ADDR_CRMANL == -9)
replace ISSU_ADDR_CYBER = . if (ISSU_ADDR_CYBER == -8 | ISSU_ADDR_CYBER == -9)
replace ISSU_ADDR_DOM = . if (ISSU_ADDR_DOM == -8 | ISSU_ADDR_DOM == -9)
replace ISSU_ADDR_GUNS = . if (ISSU_ADDR_GUNS == -8 | ISSU_ADDR_GUNS == -9)
replace ISSU_ADDR_GANG = . if (ISSU_ADDR_GANG == -8 | ISSU_ADDR_GANG == -9)
replace ISSU_ADDR_HMLS = . if (ISSU_ADDR_HMLS == -8 | ISSU_ADDR_HMLS == -9)
replace ISSU_ADDR_HUMTRF = . if (ISSU_ADDR_HUMTRF == -8 | ISSU_ADDR_HUMTRF == -9)
replace ISSU_ADDR_DUI = . if (ISSU_ADDR_DUI == -8 | ISSU_ADDR_DUI == -9)
replace ISSU_ADDR_IA = . if (ISSU_ADDR_IA == -8 | ISSU_ADDR_IA == -9)
replace ISSU_ADDR_JUV = . if (ISSU_ADDR_JUV == -8 | ISSU_ADDR_JUV == -9)
replace ISSU_ADDR_MNHLTH = . if (ISSU_ADDR_MNHLTH == -8 | ISSU_ADDR_MNHLTH == -9)
replace ISSU_ADDR_METH = . if (ISSU_ADDR_METH == -8 | ISSU_ADDR_METH == -9)
replace ISSU_ADDR_MISCHD = . if (ISSU_ADDR_MISCHD == -8 | ISSU_ADDR_MISCHD == -9)
replace ISSU_ADDR_OPIOD = . if (ISSU_ADDR_OPIOD == -8 | ISSU_ADDR_OPIOD == -9)
replace ISSU_ADDR_PARKEN = . if (ISSU_ADDR_PARKEN == -8 | ISSU_ADDR_PARKEN == -9)
replace ISSU_ADDR_PR = . if (ISSU_ADDR_PR == -8 | ISSU_ADDR_PR == -9)
replace ISSU_ADDR_RESRCH = . if (ISSU_ADDR_RESRCH == -8 | ISSU_ADDR_RESRCH == -9)
replace ISSU_ADDR_SCH = . if (ISSU_ADDR_SCH == -8 | ISSU_ADDR_SCH == -9)
replace ISSU_ADDR_SEX = . if (ISSU_ADDR_SEX == -8 | ISSU_ADDR_SEX == -9)
replace ISSU_ADDR_SWAT = . if (ISSU_ADDR_SWAT == -8 | ISSU_ADDR_SWAT == -9)
replace ISSU_ADDR_TERROR = . if (ISSU_ADDR_TERROR == -8 | ISSU_ADDR_TERROR == -9)
replace ISSU_ADDR_TRAFEN = . if (ISSU_ADDR_TRAFEN == -8 | ISSU_ADDR_TRAFEN == -9)
replace ISSU_ADDR_VIC = . if (ISSU_ADDR_VIC == -8 | ISSU_ADDR_VIC == -9)
replace OPBUDGET_2019 = . if (OPBUDGET_2019 == -8.00 | OPBUDGET_2019 == -9.00)
replace OPBUDGET_2019_EST = . if (OPBUDGET_2019_EST == -8 | OPBUDGET_2019_EST == -9)
replace OPBUDGET = . if (OPBUDGET == -8.00 | OPBUDGET == -9.00)
replace OPBUDGET_EST = . if (OPBUDGET_EST == -8 | OPBUDGET_EST == -9)
replace OP_JAIL = . if (OP_JAIL == -8 | OP_JAIL == -9)
replace OP_BUDGET_JAIL_2019 = . if (OP_BUDGET_JAIL_2019 == -8 | OP_BUDGET_JAIL_2019 == -9)
replace OP_BUDGET_JAIL_2019_EST = . if (OP_BUDGET_JAIL_2019_EST == -8 | OP_BUDGET_JAIL_2019_EST == -9)
replace OP_BUDGET_JAIL = . if (OP_BUDGET_JAIL == -8 | OP_BUDGET_JAIL == -9)
replace OP_BUDGET_JAIL_EST = . if (OP_BUDGET_JAIL_EST == -8 | OP_BUDGET_JAIL_EST == -9)
replace FY_BEGMO = . if (FY_BEGMO == -8 | FY_BEGMO == -9)
replace FY_BEGDAY = . if (FY_BEGDAY == -8 | FY_BEGDAY == -9)
replace ASSETFOR = . if (ASSETFOR == -8 | ASSETFOR == -9)
replace ASSETFOR_EST = . if (ASSETFOR_EST == -8 | ASSETFOR_EST == -9)
replace SQ_MILAGE = . if (SQ_MILAGE == -8 | SQ_MILAGE == -9)
replace RES_POP = . if (RES_POP == -8 | RES_POP == -9)
replace CP_PSP_ACD = . if (CP_PSP_ACD == -8 | CP_PSP_ACD == -9)
replace CP_PSP_ADVGRP = . if (CP_PSP_ADVGRP == -8 | CP_PSP_ADVGRP == -9)
replace CP_PSP_BUSGRP = . if (CP_PSP_BUSGRP == -8 | CP_PSP_BUSGRP == -9)
replace CP_PSP_FLEA = . if (CP_PSP_FLEA == -8 | CP_PSP_FLEA == -9)
replace CP_PSP_LEA = . if (CP_PSP_LEA == -8 | CP_PSP_LEA == -9)
replace CP_PSP_NEIGH = . if (CP_PSP_NEIGH == -8 | CP_PSP_NEIGH == -9)
replace CP_PSP_NONLEA = . if (CP_PSP_NONLEA == -8 | CP_PSP_NONLEA == -9)
replace CP_PSP_GOV = . if (CP_PSP_GOV == -8 | CP_PSP_GOV == -9)
replace CP_PSP_VICT = . if (CP_PSP_VICT == -8 | CP_PSP_VICT == -9)
replace CP_PSP_OTH = . if (CP_PSP_OTH == -8 | CP_PSP_OTH == -9)
replace FDBK_NHOOD = . if (FDBK_NHOOD == -8 | FDBK_NHOOD == -9)
replace FDBK_TRUST = . if (FDBK_TRUST == -8 | FDBK_TRUST == -9)
replace FDBK_PERFRM = . if (FDBK_PERFRM == -8 | FDBK_PERFRM == -9)
replace FDBK_POLICY = . if (FDBK_POLICY == -8 | FDBK_POLICY == -9)
replace FDBK_CRIME = . if (FDBK_CRIME == -8 | FDBK_CRIME == -9)
replace FDBK_TRAIN = . if (FDBK_TRAIN == -8 | FDBK_TRAIN == -9)
replace CP_PLAN = . if (CP_PLAN == -8 | CP_PLAN == -9)
replace CP_CPACAD = . if (CP_CPACAD == -8 | CP_CPACAD == -9)
replace CP_RANGE = . if (CP_RANGE == -8 | CP_RANGE == -9)
replace CP_CAC = . if (CP_CAC == -8 | CP_CAC == -9)
replace CP_OTH = . if (CP_OTH == -8 | CP_OTH == -9)
replace PERS_EDU_MIN = . if (PERS_EDU_MIN == -8 | PERS_EDU_MIN == -9)
replace PERS_EDU_HRS = . if (PERS_EDU_HRS == -8 | PERS_EDU_HRS == -9)
replace PERS_MIL = . if (PERS_MIL == -8 | PERS_MIL == -9)
replace PERS_BACKINV = . if (PERS_BACKINV == -8 | PERS_BACKINV == -9)
replace PERS_CREDHIS = . if (PERS_CREDHIS == -8 | PERS_CREDHIS == -9)
replace PERS_CRIMHIS = . if (PERS_CRIMHIS == -8 | PERS_CRIMHIS == -9)
replace PERS_DRIVHIS = . if (PERS_DRIVHIS == -8 | PERS_DRIVHIS == -9)
replace PERS_SOCMED = . if (PERS_SOCMED == -8 | PERS_SOCMED == -9)
replace PERS_COG = . if (PERS_COG == -8 | PERS_COG == -9)
replace PERS_INTERPER = . if (PERS_INTERPER == -8 | PERS_INTERPER == -9)
replace PERS_PERSTEST = . if (PERS_PERSTEST == -8 | PERS_PERSTEST == -9)
replace PERS_PSYCH = . if (PERS_PSYCH == -8 | PERS_PSYCH == -9)
replace PERS_POLY = . if (PERS_POLY == -8 | PERS_POLY == -9)
replace PERS_DRUG = . if (PERS_DRUG == -8 | PERS_DRUG == -9)
replace PERS_MED = . if (PERS_MED == -8 | PERS_MED == -9)
replace PERS_VISN = . if (PERS_VISN == -8 | PERS_VISN == -9)
replace PERS_PHYS = . if (PERS_PHYS == -8 | PERS_PHYS == -9)
replace PERS_SSTAND = . if (PERS_SSTAND == -8 | PERS_SSTAND == -9)
replace ACAD_HRS_ST = . if (ACAD_HRS_ST == -8 | ACAD_HRS_ST == -9)
replace FLD_HRS_ST = . if (FLD_HRS_ST == -8 | FLD_HRS_ST == -9)
replace ACAD_HRS_ADD = . if (ACAD_HRS_ADD == -8 | ACAD_HRS_ADD == -9)
replace FLD_HRS_ADD = . if (FLD_HRS_ADD == -8 | FLD_HRS_ADD == -9)
replace PERS_TRN_ACAD = . if (PERS_TRN_ACAD == -8 | PERS_TRN_ACAD == -9)
replace PERS_TRN_FIELD = . if (PERS_TRN_FIELD == -8 | PERS_TRN_FIELD == -9)
replace STATE_TRN_MIN = . if (STATE_TRN_MIN == -8 | STATE_TRN_MIN == -9)
replace ADD_TRN_MIN = . if (ADD_TRN_MIN == -8 | ADD_TRN_MIN == -9)
replace PERS_TRN_INSVC = . if (PERS_TRN_INSVC == -8 | PERS_TRN_INSVC == -9)
replace TOT_NEW = . if (TOT_NEW == -8 | TOT_NEW == -9)
replace NON_LAT_NEW = . if (NON_LAT_NEW == -8 | NON_LAT_NEW == -9)
replace LAT_TRANSF = . if (LAT_TRANSF == -8 | LAT_TRANSF == -9)
replace OTH_NEW = . if (OTH_NEW == -8 | OTH_NEW == -9)
replace AVG_WKS = . if (AVG_WKS == -8 | AVG_WKS == -9)
replace FOUR_YR_COLL_GRAD = . if (FOUR_YR_COLL_GRAD == -8 | FOUR_YR_COLL_GRAD == -9)
replace MIL_VET = . if (MIL_VET == -8 | MIL_VET == -9)
replace MULT_LING = . if (MULT_LING == -8 | MULT_LING == -9)
replace PRIOR_EXP = . if (PRIOR_EXP == -8 | PRIOR_EXP == -9)
replace RACE_ETHNI_MIN = . if (RACE_ETHNI_MIN == -8 | RACE_ETHNI_MIN == -9)
replace WMN = . if (WMN == -8 | WMN == -9)
replace OTH_TAR = . if (OTH_TAR == -8 | OTH_TAR == -9)
replace SIGN_BONUS = . if (SIGN_BONUS == -8 | SIGN_BONUS == -9)
replace FREE_TRN = . if (FREE_TRN == -8 | FREE_TRN == -9)
replace SALARY = . if (SALARY == -8 | SALARY == -9)
replace GRAD_BONUS = . if (GRAD_BONUS == -8 | GRAD_BONUS == -9)
replace RELOC_ASST = . if (RELOC_ASST == -8 | RELOC_ASST == -9)
replace OTH_INCEN = . if (OTH_INCEN == -8 | OTH_INCEN == -9)
replace TOT_SEP = . if (TOT_SEP == -8 | TOT_SEP == -9)
replace PROB_REJ = . if (PROB_REJ == -8 | PROB_REJ == -9)
replace LAYOFF = . if (LAYOFF == -8 | LAYOFF == -9)
replace DISMISS = . if (DISMISS == -8 | DISMISS == -9)
replace RESIGN = . if (RESIGN == -8 | RESIGN == -9)
replace MED_RETIRE = . if (MED_RETIRE == -8 | MED_RETIRE == -9)
replace NON_MED_RETIRE = . if (NON_MED_RETIRE == -8 | NON_MED_RETIRE == -9)
replace DEATH = . if (DEATH == -8 | DEATH == -9)
replace OTH_SEP = . if (OTH_SEP == -8 | OTH_SEP == -9)
replace EXIT_INT = . if (EXIT_INT == -8 | EXIT_INT == -9)
replace BAS_CHIEF_EXEC_MIN = . if (BAS_CHIEF_EXEC_MIN == -8 | BAS_CHIEF_EXEC_MIN == -9)
replace BAS_CHIEF_EXEC_MAX = . if (BAS_CHIEF_EXEC_MAX == -8 | BAS_CHIEF_EXEC_MAX == -9)
replace BAS_CHIEF_EXEC_NA = . if (BAS_CHIEF_EXEC_NA == -8 | BAS_CHIEF_EXEC_NA == -9)
replace BAS_SGT_MIN = . if (BAS_SGT_MIN == -8 | BAS_SGT_MIN == -9)
replace BAS_SGT_MAX = . if (BAS_SGT_MAX == -8 | BAS_SGT_MAX == -9)
replace BAS_SGT_NA = . if (BAS_SGT_NA == -8 | BAS_SGT_NA == -9)
replace BAS_OFC_MIN = . if (BAS_OFC_MIN == -8 | BAS_OFC_MIN == -9)
replace BAS_OFC_MAX = . if (BAS_OFC_MAX == -8 | BAS_OFC_MAX == -9)
replace BAS_OFC_NA = . if (BAS_OFC_NA == -8 | BAS_OFC_NA == -9)
replace PAY_BIL = . if (PAY_BIL == -8 | PAY_BIL == -9)
replace PAY_EDU = . if (PAY_EDU == -8 | PAY_EDU == -9)
replace PAY_HAZ = . if (PAY_HAZ == -8 | PAY_HAZ == -9)
replace PAY_MRT = . if (PAY_MRT == -8 | PAY_MRT == -9)
replace PAY_MIL = . if (PAY_MIL == -8 | PAY_MIL == -9)
replace PAY_RES = . if (PAY_RES == -8 | PAY_RES == -9)
replace PAY_SHFT_DIF = . if (PAY_SHFT_DIF == -8 | PAY_SHFT_DIF == -9)
replace PAY_SKL = . if (PAY_SKL == -8 | PAY_SKL == -9)
replace TUITION = . if (TUITION == -8 | TUITION == -9)
replace EAP = . if (EAP == -8 | EAP == -9)
replace MED_BNFT = . if (MED_BNFT == -8 | MED_BNFT == -9)
replace RETIRE_BNFT = . if (RETIRE_BNFT == -8 | RETIRE_BNFT == -9)
replace OT = . if (OT == -8 | OT == -9)
replace FLEX_HRS_COLL = . if (FLEX_HRS_COLL == -8 | FLEX_HRS_COLL == -9)
replace CLOTH_ALLOW = . if (CLOTH_ALLOW == -8 | CLOTH_ALLOW == -9)
replace HOUSE_ALLOW = . if (HOUSE_ALLOW == -8 | HOUSE_ALLOW == -9)
replace PAY_INC = . if (PAY_INC == -8 | PAY_INC == -9)
replace JOB_SHARE = . if (JOB_SHARE == -8 | JOB_SHARE == -9)
replace ON_DUTY_FIT = . if (ON_DUTY_FIT == -8 | ON_DUTY_FIT == -9)
replace MAT_LVE = . if (MAT_LVE == -8 | MAT_LVE == -9)
replace PAT_LVE = . if (PAT_LVE == -8 | PAT_LVE == -9)
replace PEER_SUP = . if (PEER_SUP == -8 | PEER_SUP == -9)
replace RELAX_RES_REQ = . if (RELAX_RES_REQ == -8 | RELAX_RES_REQ == -9)
replace TAKE_HOME_VEH = . if (TAKE_HOME_VEH == -8 | TAKE_HOME_VEH == -9)
replace OTH_BNFT = . if (OTH_BNFT == -8 | OTH_BNFT == -9)
replace STD_SHFT = . if (STD_SHFT == -8 | STD_SHFT == -9)
replace EQ_HANDGUN_ON = . if (EQ_HANDGUN_ON == -8 | EQ_HANDGUN_ON == -9)
replace EQ_HANDGUN_OFF = . if (EQ_HANDGUN_OFF == -8 | EQ_HANDGUN_OFF == -9)
replace EQ_SHOTGUN_ON = . if (EQ_SHOTGUN_ON == -8 | EQ_SHOTGUN_ON == -9)
replace EQ_SHOTGUN_OFF = . if (EQ_SHOTGUN_OFF == -8 | EQ_SHOTGUN_OFF == -9)
replace EQ_SEMI_ON = . if (EQ_SEMI_ON == -8 | EQ_SEMI_ON == -9)
replace EQ_SEMI_OFF = . if (EQ_SEMI_OFF == -8 | EQ_SEMI_OFF == -9)
replace EQ_FULL_AUTO_ON = . if (EQ_FULL_AUTO_ON == -8 | EQ_FULL_AUTO_ON == -9)
replace EQ_FULL_AUTO_OFF = . if (EQ_FULL_AUTO_OFF == -8 | EQ_FULL_AUTO_OFF == -9)
replace EQ_OHAND = . if (EQ_OHAND == -8 | EQ_OHAND == -9)
replace EQ_CHAND = . if (EQ_CHAND == -8 | EQ_CHAND == -9)
replace EQ_TKDWN = . if (EQ_TKDWN == -8 | EQ_TKDWN == -9)
replace EQ_NECK_VASC = . if (EQ_NECK_VASC == -8 | EQ_NECK_VASC == -9)
replace EQ_NECK_RESP = . if (EQ_NECK_RESP == -8 | EQ_NECK_RESP == -9)
replace EQ_LEG = . if (EQ_LEG == -8 | EQ_LEG == -9)
replace EQ_OC = . if (EQ_OC == -8 | EQ_OC == -9)
replace EQ_CHEM = . if (EQ_CHEM == -8 | EQ_CHEM == -9)
replace EQ_BTN = . if (EQ_BTN == -8 | EQ_BTN == -9)
replace EQ_BLNT = . if (EQ_BLNT == -8 | EQ_BLNT == -9)
replace EQ_CED = . if (EQ_CED == -8 | EQ_CED == -9)
replace EQ_OTH = . if (EQ_OTH == -8 | EQ_OTH == -9)
replace EQ_VID_FIXED = . if (EQ_VID_FIXED == -8 | EQ_VID_FIXED == -9)
replace EQ_VID_MOBILE = . if (EQ_VID_MOBILE == -8 | EQ_VID_MOBILE == -9)
replace EQ_VID_DRONE = . if (EQ_VID_DRONE == -8 | EQ_VID_DRONE == -9)
replace EQ_VID_CAR = . if (EQ_VID_CAR == -8 | EQ_VID_CAR == -9)
replace EQ_VID_BWC = . if (EQ_VID_BWC == -8 | EQ_VID_BWC == -9)
replace EQ_VID_WEAP = . if (EQ_VID_WEAP == -8 | EQ_VID_WEAP == -9)
replace K9_HAND = . if (K9_HAND == -8 | K9_HAND == -9)
replace K9_DOG = . if (K9_DOG == -8 | K9_DOG == -9)
replace K9_BOMB = . if (K9_BOMB == -8 | K9_BOMB == -9)
replace K9_CADAVER = . if (K9_CADAVER == -8 | K9_CADAVER == -9)
replace K9_DRUG = . if (K9_DRUG == -8 | K9_DRUG == -9)
replace K9_INDV = . if (K9_INDV == -8 | K9_INDV == -9)
replace K9_GEN = . if (K9_GEN == -8 | K9_GEN == -9)
replace K9_OTH = . if (K9_OTH == -8 | K9_OTH == -9)
replace CP_WEB = . if (CP_WEB == -8 | CP_WEB == -9)
replace CP_SM = . if (CP_SM == -8 | CP_SM == -9)
replace TECH_TYP_CAD = . if (TECH_TYP_CAD == -8 | TECH_TYP_CAD == -9)
replace TECH_TYP_RMS = . if (TECH_TYP_RMS == -8 | TECH_TYP_RMS == -9)
replace TECH_TYP_AFIS = . if (TECH_TYP_AFIS == -8 | TECH_TYP_AFIS == -9)
replace TECH_TYP_GIS = . if (TECH_TYP_GIS == -8 | TECH_TYP_GIS == -9)
replace TECH_TYP_FACEREC = . if (TECH_TYP_FACEREC == -8 | TECH_TYP_FACEREC == -9)
replace TECH_TYP_INFR = . if (TECH_TYP_INFR == -8 | TECH_TYP_INFR == -9)
replace TECH_TYP_LPR = . if (TECH_TYP_LPR == -8 | TECH_TYP_LPR == -9)
replace TECH_TYP_TIREDFL = . if (TECH_TYP_TIREDFL == -8 | TECH_TYP_TIREDFL == -9)
replace TECH_TYP_GUNSHOT = . if (TECH_TYP_GUNSHOT == -8 | TECH_TYP_GUNSHOT == -9)
replace TECH_TYP_TRACE = . if (TECH_TYP_TRACE == -8 | TECH_TYP_TRACE == -9)
replace TECH_TYP_BALL = . if (TECH_TYP_BALL == -8 | TECH_TYP_BALL == -9)
replace DATA_BUDGET = . if (DATA_BUDGET == -8 | DATA_BUDGET == -9)
replace DATA_HSA = . if (DATA_HSA == -8 | DATA_HSA == -9)
replace DATA_INTEL = . if (DATA_INTEL == -8 | DATA_INTEL == -9)
replace DATA_PATROL = . if (DATA_PATROL == -8 | DATA_PATROL == -9)
replace DATA_PRED = . if (DATA_PRED == -8 | DATA_PRED == -9)
replace DATA_SNA = . if (DATA_SNA == -8 | DATA_SNA == -9)
replace DATA_TARG = . if (DATA_TARG == -8 | DATA_TARG == -9)
replace POL_CONDUCT = . if (POL_CONDUCT == -8 | POL_CONDUCT == -9)
replace POL_MAXHRS = . if (POL_MAXHRS == -8 | POL_MAXHRS == -9)
replace POL_MAXHRS_SPC = . if (POL_MAXHRS_SPC == -8 | POL_MAXHRS_SPC == -9)
replace POL_OFFDTY = . if (POL_OFFDTY == -8 | POL_OFFDTY == -9)
replace POL_DCHG_GUN = . if (POL_DCHG_GUN == -8 | POL_DCHG_GUN == -9)
replace POL_DEADFORC = . if (POL_DEADFORC == -8 | POL_DEADFORC == -9)
replace POL_LESSLETHAL = . if (POL_LESSLETHAL == -8 | POL_LESSLETHAL == -9)
replace POL_DOMDISP = . if (POL_DOMDISP == -8 | POL_DOMDISP == -9)
replace POL_HOMELESS = . if (POL_HOMELESS == -8 | POL_HOMELESS == -9)
replace POL_JUV = . if (POL_JUV == -8 | POL_JUV == -9)
replace POL_MENTILL = . if (POL_MENTILL == -8 | POL_MENTILL == -9)
replace POL_DEVDISABLE = . if (POL_DEVDISABLE == -8 | POL_DEVDISABLE == -9)
replace POL_ACTSHOOT = . if (POL_ACTSHOOT == -8 | POL_ACTSHOOT == -9)
replace POL_BWC = . if (POL_BWC == -8 | POL_BWC == -9)
replace POL_IMMSTAT = . if (POL_IMMSTAT == -8 | POL_IMMSTAT == -9)
replace POL_COMPL = . if (POL_COMPL == -8 | POL_COMPL == -9)
replace POL_COVID = . if (POL_COVID == -8 | POL_COVID == -9)
replace POL_IMMDET = . if (POL_IMMDET == -8 | POL_IMMDET == -9)
replace POL_INCUSDTH = . if (POL_INCUSDTH == -8 | POL_INCUSDTH == -9)
replace POL_MASSDEM = . if (POL_MASSDEM == -8 | POL_MASSDEM == -9)
replace POL_MVSTOP = . if (POL_MVSTOP == -8 | POL_MVSTOP == -9)
replace POL_PRISTRP = . if (POL_PRISTRP == -8 | POL_PRISTRP == -9)
replace POL_RACPROF = . if (POL_RACPROF == -8 | POL_RACPROF == -9)
replace POL_REPUOF = . if (POL_REPUOF == -8 | POL_REPUOF == -9)
replace POL_SOCMED = . if (POL_SOCMED == -8 | POL_SOCMED == -9)
replace POL_STFRSK = . if (POL_STFRSK == -8 | POL_STFRSK == -9)
replace POL_STRPSRCH = . if (POL_STRPSRCH == -8 | POL_STRPSRCH == -9)
replace POL_VEHPURS = . if (POL_VEHPURS == -8 | POL_VEHPURS == -9)
replace COVID_OFFSELFSCREEN = . if (COVID_OFFSELFSCREEN == -8 | COVID_OFFSELFSCREEN == -9)
replace COVID_OFFPPEPATROL = . if (COVID_OFFPPEPATROL == -8 | COVID_OFFPPEPATROL == -9)
replace COVID_OFFPPESTATION = . if (COVID_OFFPPESTATION == -8 | COVID_OFFPPESTATION == -9)
replace COVID_OFFTEST = . if (COVID_OFFTEST == -8 | COVID_OFFTEST == -9)
replace COVID_OFFEXP = . if (COVID_OFFEXP == -8 | COVID_OFFEXP == -9)
replace COVID_CLEANSTN = . if (COVID_CLEANSTN == -8 | COVID_CLEANSTN == -9)
replace COVID_CLEANCAR = . if (COVID_CLEANCAR == -8 | COVID_CLEANCAR == -9)
replace COVID_CUSTPPE = . if (COVID_CUSTPPE == -8 | COVID_CUSTPPE == -9)
replace COVID_CUSTSYMP = . if (COVID_CUSTSYMP == -8 | COVID_CUSTSYMP == -9)
replace COVID_INMCLEANSUP = . if (COVID_INMCLEANSUP == -8 | COVID_INMCLEANSUP == -9)
replace COVID_INMCLEANAREA = . if (COVID_INMCLEANAREA == -8 | COVID_INMCLEANAREA == -9)
replace COVID_OFFPPEJAIL = . if (COVID_OFFPPEJAIL == -8 | COVID_OFFPPEJAIL == -9)
replace COVID_INMPPE = . if (COVID_INMPPE == -8 | COVID_INMPPE == -9)
replace COVID_CHANGE_FOOTPATROL_POLICY = . if (COVID_CHANGE_FOOTPATROL_POLICY == -8 | COVID_CHANGE_FOOTPATROL_POLICY == -9)
replace COVID_CHANGE_FOOTPATROL_PRACTICE = . if (COVID_CHANGE_FOOTPATROL_PRACTICE == -8 | COVID_CHANGE_FOOTPATROL_PRACTICE == -9)
replace COVID_CHANGE_FOOTPATROL_NOCHANGE = . if (COVID_CHANGE_FOOTPATROL_NOCHANGE == -8 | COVID_CHANGE_FOOTPATROL_NOCHANGE == -9)
replace COVID_CHANGE_CARPATROL_POLICY = . if (COVID_CHANGE_CARPATROL_POLICY == -8 | COVID_CHANGE_CARPATROL_POLICY == -9)
replace COVID_CHANGE_CARPATROL_PRACTICE = . if (COVID_CHANGE_CARPATROL_PRACTICE == -8 | COVID_CHANGE_CARPATROL_PRACTICE == -9)
replace COVID_CHANGE_CARPATROL_NOCHANGE = . if (COVID_CHANGE_CARPATROL_NOCHANGE == -8 | COVID_CHANGE_CARPATROL_NOCHANGE == -9)
replace COVID_CHANGE_ARREST_POLICY = . if (COVID_CHANGE_ARREST_POLICY == -8 | COVID_CHANGE_ARREST_POLICY == -9)
replace COVID_CHANGE_ARREST_PRACTICE = . if (COVID_CHANGE_ARREST_PRACTICE == -8 | COVID_CHANGE_ARREST_PRACTICE == -9)
replace COVID_CHANGE_ARREST_NOCHANGE = . if (COVID_CHANGE_ARREST_NOCHANGE == -8 | COVID_CHANGE_ARREST_NOCHANGE == -9)
replace COVID_CHANGE_INVEST_POLICY = . if (COVID_CHANGE_INVEST_POLICY == -8 | COVID_CHANGE_INVEST_POLICY == -9)
replace COVID_CHANGE_INVEST_PRACTICE = . if (COVID_CHANGE_INVEST_PRACTICE == -8 | COVID_CHANGE_INVEST_PRACTICE == -9)
replace COVID_CHANGE_INVEST_NOCHANGE = . if (COVID_CHANGE_INVEST_NOCHANGE == -8 | COVID_CHANGE_INVEST_NOCHANGE == -9)
replace COVID_CHANGE_VICSERV_POLICY = . if (COVID_CHANGE_VICSERV_POLICY == -8 | COVID_CHANGE_VICSERV_POLICY == -9)
replace COVID_CHANGE_VICSERV_PRACTICE = . if (COVID_CHANGE_VICSERV_PRACTICE == -8 | COVID_CHANGE_VICSERV_PRACTICE == -9)
replace COVID_CHANGE_VICSERV_NOCHANGE = . if (COVID_CHANGE_VICSERV_NOCHANGE == -8 | COVID_CHANGE_VICSERV_NOCHANGE == -9)
replace COVID_CHANGE_COMMUNITY_POLICY = . if (COVID_CHANGE_COMMUNITY_POLICY == -8 | COVID_CHANGE_COMMUNITY_POLICY == -9)
replace COVID_CHANGE_COMMUNITY_PRACTICE = . if (COVID_CHANGE_COMMUNITY_PRACTICE == -8 | COVID_CHANGE_COMMUNITY_PRACTICE == -9)
replace COVID_CHANGE_COMMUNITY_NOCHANGE = . if (COVID_CHANGE_COMMUNITY_NOCHANGE == -8 | COVID_CHANGE_COMMUNITY_NOCHANGE == -9)
replace COVID_CHANGE_OTH_POLICY = . if (COVID_CHANGE_OTH_POLICY == -8 | COVID_CHANGE_OTH_POLICY == -9)
replace COVID_CHANGE_OTH_PRACTICE = . if (COVID_CHANGE_OTH_PRACTICE == -8 | COVID_CHANGE_OTH_PRACTICE == -9)
replace COVID_CHANGE_OTH_NOCHANGE = . if (COVID_CHANGE_OTH_NOCHANGE == -8 | COVID_CHANGE_OTH_NOCHANGE == -9)
replace IMMSTAT_PEDSTP = . if (IMMSTAT_PEDSTP == -8 | IMMSTAT_PEDSTP == -9)
replace IMMSTAT_TRFSTP = . if (IMMSTAT_TRFSTP == -8 | IMMSTAT_TRFSTP == -9)
replace IMMSTAT_MISD = . if (IMMSTAT_MISD == -8 | IMMSTAT_MISD == -9)
replace IMMSTAT_FEL = . if (IMMSTAT_FEL == -8 | IMMSTAT_FEL == -9)
replace IMMSTAT_FEDVIO = . if (IMMSTAT_FEDVIO == -8 | IMMSTAT_FEDVIO == -9)
replace IMMSTAT_HMLD = . if (IMMSTAT_HMLD == -8 | IMMSTAT_HMLD == -9)
replace IMMSTAT_POL = . if (IMMSTAT_POL == -8 | IMMSTAT_POL == -9)
replace IMMSTAT_STLEG = . if (IMMSTAT_STLEG == -8 | IMMSTAT_STLEG == -9)
replace IMMSTAT_FLD = . if (IMMSTAT_FLD == -8 | IMMSTAT_FLD == -9)
replace IMMSTAT_VICT = . if (IMMSTAT_VICT == -8 | IMMSTAT_VICT == -9)
replace IMMSTAT_RACPROF = . if (IMMSTAT_RACPROF == -8 | IMMSTAT_RACPROF == -9)
replace IMMSTAT_PUBTRUST = . if (IMMSTAT_PUBTRUST == -8 | IMMSTAT_PUBTRUST == -9)
replace IMMSTAT_OTH = . if (IMMSTAT_OTH == -8 | IMMSTAT_OTH == -9)
replace TECH_EIS = . if (TECH_EIS == -8 | TECH_EIS == -9)
replace COMPL_ALL_SUST = . if (COMPL_ALL_SUST == -8 | COMPL_ALL_SUST == -9)
replace COMPL_UOF_SUST = . if (COMPL_UOF_SUST == -8 | COMPL_UOF_SUST == -9)
replace COMPL_ALL_OTH = . if (COMPL_ALL_OTH == -8 | COMPL_ALL_OTH == -9)
replace COMPL_UOF_OTH = . if (COMPL_UOF_OTH == -8 | COMPL_UOF_OTH == -9)
replace COMPL_ALL_PEND = . if (COMPL_ALL_PEND == -8 | COMPL_ALL_PEND == -9)
replace COMPL_UOF_PEND = . if (COMPL_UOF_PEND == -8 | COMPL_UOF_PEND == -9)
replace COMPL_ALL_TOT = . if (COMPL_ALL_TOT == -8 | COMPL_ALL_TOT == -9)
replace COMPL_UOF_TOT = . if (COMPL_UOF_TOT == -8 | COMPL_UOF_TOT == -9)
replace CIV_COMPL = . if (CIV_COMPL == -8 | CIV_COMPL == -9)
replace POL_INV_DCHG_GUN = . if (POL_INV_DCHG_GUN == -8 | POL_INV_DCHG_GUN == -9)
replace POL_INV_INJURY = . if (POL_INV_INJURY == -8 | POL_INV_INJURY == -9)
replace POL_INV_DTH = . if (POL_INV_DTH == -8 | POL_INV_DTH == -9)
replace POL_INV_ICD = . if (POL_INV_ICD == -8 | POL_INV_ICD == -9)
replace MODE = . if (MODE == -8)
replace PRIMARYPOP2020 = . if (PRIMARYPOP2020 == -8)
replace SECONDARYPOP2020 = . if (SECONDARYPOP2020 == -8)
replace EDIT_FTSWORN = . if (EDIT_FTSWORN == -8)
replace COMPLETE = . if (COMPLETE == -8)


